UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1K7fH9ZgJQLsgSQEW4LImTSw/my4+h0710lDYaX0Yuc='
WHERE
key_id = '472defaeebbd2b60e2e4203d7c492b17aa18538aa2c567bbf00b2ae37079fd6e'
AND (
token = '1K7fH9ZgJQLsgSQEW4LImTSw/my4+h0710lDYaX0Yuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)