UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKZkzBIUr4HgBXll6tnKAH/N8M9iQ9uEDtgTsvHSwng='
WHERE
key_id = '10ed16d77fd4e86e0a2fc78b934ced7467132fe93fb24a93e6bf38fe225f5e97'
AND (
token = 'LKZkzBIUr4HgBXll6tnKAH/N8M9iQ9uEDtgTsvHSwng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)