UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y/YWkIPS11y+wO7yq5smDo7py7DP24X5aSWD6hW+lvk='
WHERE
key_id = 'e82ec9e18f602c34943e229cb9dd50981b32ec902e76a05aa2c35a8daae7103c'
AND (
token = 'y/YWkIPS11y+wO7yq5smDo7py7DP24X5aSWD6hW+lvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)