UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yk4/SARlyOeR+dCiI5RUoIY09xzWcAF+33f4u5z7Bj0='
WHERE
key_id = 'aecf9c1201831a616cf3f01f1c59d6708856cbca2449199bb852483a986cd9cc'
AND (
token = 'yk4/SARlyOeR+dCiI5RUoIY09xzWcAF+33f4u5z7Bj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)