UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c7cvVUUvXYacDj7Pxv9PVb73be8sKy5hsuFD4GupHng='
WHERE
key_id = '0cf77753c1b98404e8cc6fce8a183bb34d89d032e882a3358971ce75a3044f39'
AND (
token = 'c7cvVUUvXYacDj7Pxv9PVb73be8sKy5hsuFD4GupHng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)