UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xrVYoulQf2lqwAAJ56CxT3lxxyGme5JbouUB/o1VKU='
WHERE
key_id = '300ae4bd12b7744939a7e9698af10314e3f07976103d751ddd1d049b1e096788'
AND (
token = '7xrVYoulQf2lqwAAJ56CxT3lxxyGme5JbouUB/o1VKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)