UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nr5sE8e3sGUIUNbma1Ev4cTZEluaysym0rXpXR6M3mk='
WHERE
key_id = '31cf6d55e735f28150e64a2c9c43b8111c8aef49fc3d5b83eaf6907fc46a869f'
AND (
token = 'Nr5sE8e3sGUIUNbma1Ev4cTZEluaysym0rXpXR6M3mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)