UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7vojGPjgbOU8I20ggagg1EJhZsV/LlG06zVV5hiOp4='
WHERE
key_id = '79a42f878eb84e2622cbb304e7c3d5c4d4d4bf3b4494cac0ee87e4272cc0b4cb'
AND (
token = 'J7vojGPjgbOU8I20ggagg1EJhZsV/LlG06zVV5hiOp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)