UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9hGd7VzoS88CdwhUx9UssnZmV8lS3WGBvcfY7K9ZgE='
WHERE
key_id = 'c16d320228bb5a18b76d6020030d7a9aac7edeb2b92a02e67c03e5c2713dc2ae'
AND (
token = 'o9hGd7VzoS88CdwhUx9UssnZmV8lS3WGBvcfY7K9ZgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)