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