UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJkudVGXxVVb2rkC1vEq9Dk26AQ80VRb4PTBf+zxkXE='
WHERE
key_id = 'f7077339d775188e9883bfea7a3e373ce1e65579cc9a1c1843e98f2d3ce4d867'
AND (
token = 'DJkudVGXxVVb2rkC1vEq9Dk26AQ80VRb4PTBf+zxkXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)