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