UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ydMsUSvIAvJ5ehs9Nm7SJq47DROI3RdiM0xdshbvBuc='
WHERE
key_id = '8e04714b2071d4e76e6960032ba4a8440dbdce9289da3f0fc16660805902eecf'
AND (
token = 'ydMsUSvIAvJ5ehs9Nm7SJq47DROI3RdiM0xdshbvBuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)