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