UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXknTIzYPDeVyydoLoa3dEpTIzLdBOUpln5al8Kha+c='
WHERE
key_id = '3bfcb4e8cf5e2679fcf678c52e99c4769cb753c5281b7d74f178a68d7cab2ac7'
AND (
token = 'fXknTIzYPDeVyydoLoa3dEpTIzLdBOUpln5al8Kha+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)