UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgXd9coDsczCQb9+Ei31V/D0dr+dp2K33YLQxdD6U/o='
WHERE
key_id = 'bcda2704d389d5e003eac08fc619932fb9b473be49b3c3020eda213dd66e80b2'
AND (
token = 'SgXd9coDsczCQb9+Ei31V/D0dr+dp2K33YLQxdD6U/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)