UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pH27+Z7zo2pWINZxzbUwmC6W6lnJpOCx4EzZZJDYcTo='
WHERE
key_id = 'd77a55b8c0744f309bacc43ddc83963ef4d9e8297285871f768d6088feced78b'
AND (
token = 'pH27+Z7zo2pWINZxzbUwmC6W6lnJpOCx4EzZZJDYcTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)