UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1+D/PD5ym/dW15cJzxARpOHW+LyjBepq3bjFgO+zFk='
WHERE
key_id = 'e77afb28efdc43ba04a9690b22545bdaf7f42086b83fcd268a3b8945b54f1fa1'
AND (
token = 'x1+D/PD5ym/dW15cJzxARpOHW+LyjBepq3bjFgO+zFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)