UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btxtpZtPPGpFcNkylXK607eCxYbRs/281adm3MYqTic='
WHERE
key_id = '00a1391ded1cd3dae74f414ac098987459dc839262f9904906373f9d7fb77c6a'
AND (
token = 'btxtpZtPPGpFcNkylXK607eCxYbRs/281adm3MYqTic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)