UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fE8czqjdOydSNwmQGzmN7BD4gaSklHOP8Oz7VCVG+VE='
WHERE
key_id = '3627f5d0350c8504ffa66934262bf9e60a9a79374deb9a140fb0a6a96fbb26e9'
AND (
token = 'fE8czqjdOydSNwmQGzmN7BD4gaSklHOP8Oz7VCVG+VE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)