UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZ67iEF8g8RCcCK4N+sZlF3x9+UjFpuFgT8Si46QmMY='
WHERE
key_id = 'cad8a362c42a408bf4748fe9aa9e37ffa7bfc6acea3ffb9d67b1faa9bfdb13b0'
AND (
token = 'TZ67iEF8g8RCcCK4N+sZlF3x9+UjFpuFgT8Si46QmMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)