UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crZPZiKIzYQA0oE8UbsgB8nR6aDL+spBdCmvaJL84uM='
WHERE
key_id = 'c84218f8422b21632d5091e5a8f82660c468e223cc8be2effc4ac894c53f6e03'
AND (
token = 'crZPZiKIzYQA0oE8UbsgB8nR6aDL+spBdCmvaJL84uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)