UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmrIypo2cpsc61SolxVxV7PfNWNmGnxqZVoMcPAA0oU='
WHERE
key_id = 'dce9b7e3e00f33ba3785ea1fe82c2d2dedbf48e7930912a9b4a311193917f31a'
AND (
token = 'BmrIypo2cpsc61SolxVxV7PfNWNmGnxqZVoMcPAA0oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)