UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BKcwBuZU5FkQhD0COyoWRrSUeVMQjln8dq9JcoKgLEA='
WHERE
key_id = '4596683bfd3d2f96346fcf309c82de3e74ea23b985a5a339111e91497873610b'
AND (
token = 'BKcwBuZU5FkQhD0COyoWRrSUeVMQjln8dq9JcoKgLEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)