UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VUbeN58JzI9xIFMinpH6mR+GspJNYeY0ebKG240xgw='
WHERE
key_id = 'd49d84a2159fa96b8ecdd0c427744c35a002f2e92577471aff6f49a3b5a5eb42'
AND (
token = '/VUbeN58JzI9xIFMinpH6mR+GspJNYeY0ebKG240xgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)