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