UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZbEcihn2ycEaBS5lgtrmB1k/7yHXKLTYN+fLI/YukqU='
WHERE
key_id = '54ca248d157b90a5f095efde0fb8aa4d486a763334127da7b0199e46db137018'
AND (
token = 'ZbEcihn2ycEaBS5lgtrmB1k/7yHXKLTYN+fLI/YukqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)