UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XSjnsxfEuzzIlM6e9t6WRle+897sQ6VxgbN10oEzLYM='
WHERE
key_id = 'cfec1d232b5ebbff393667941df0cc3255135eadff1c6318a70445a54dd250b0'
AND (
token = 'XSjnsxfEuzzIlM6e9t6WRle+897sQ6VxgbN10oEzLYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)