UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjdW8ueFXKlYwZPooWOkaeWQnzPuD231eSF5Fw8uYDA='
WHERE
key_id = 'f8d50e92ba299553155938b8eb5b91a79b77c46af2f6dc1b320489f190c42eda'
AND (
token = 'BjdW8ueFXKlYwZPooWOkaeWQnzPuD231eSF5Fw8uYDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)