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