UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lC7lJkoejEKcECCuxf3j+icZZrr4eiF/064Xao15Z5k='
WHERE
key_id = 'd67563151937f52ae9dd7a1a72b90a33444c5051d4fad7b0916c92f1ba23fd90'
AND (
token = 'lC7lJkoejEKcECCuxf3j+icZZrr4eiF/064Xao15Z5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)