UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VLifA0OAYbVJ9rIg1Qteock0SuI7TIVMrjatd25z+q0='
WHERE
key_id = '7f034d2ba5ba5f6dcd48d685bac8807b10730f2b08a4fd147f7cdf6100d6d426'
AND (
token = 'VLifA0OAYbVJ9rIg1Qteock0SuI7TIVMrjatd25z+q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)