UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2s9OktIkAmkOg1n0ZH+Xgp4v0iKQHnNYfg+vmOPD5Ng='
WHERE
key_id = 'b204bf3d940dd565ab7cde551db331bba4caeaa05536c439376742fe2c938ef0'
AND (
token = '2s9OktIkAmkOg1n0ZH+Xgp4v0iKQHnNYfg+vmOPD5Ng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)