UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBFxmFkfmJtBnXIXrGVSKMLIsLxyaOqkh3X506t8j3s='
WHERE
key_id = '11d1405e9d7700d90afa57c287d4b05483cda34c3ae6d0902d05287c3324e28e'
AND (
token = 'XBFxmFkfmJtBnXIXrGVSKMLIsLxyaOqkh3X506t8j3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)