UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9OUHqXpUJ6CWtU6SnHfDX0Dqoo8WM0vIVI2Hw12rOV0='
WHERE
key_id = '30340c9a3b6856aef27ca52661ca84d0c161b9087d5190e0e7bdbf38ff3afaef'
AND (
token = '9OUHqXpUJ6CWtU6SnHfDX0Dqoo8WM0vIVI2Hw12rOV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)